/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.autosalon.tools;

/**
 *
 * @author s0vet
 */
public class Constants {
    
    //database constants and parameters
    
    public static final String DB_ADRESA_ID = "id";
    public static final String DB_ADRESA_CO = "co";
    public static final String DB_ADRESA_CP = "cp";
    public static final String DB_ADRESA_MESTO = "mesto";
    public static final String DB_ADRESA_PSC = "psc";
    public static final String DB_ADRESA_STAT = "stat";
    public static final String DB_ADRESA_ULICE = "ulice";
    public static final String DB_ADRESA_ZAKAZNIK_ID = "zakaznik_id";
    
    public static final String DB_AUTOMOBIL_ID = "id";
    public static final String DB_AUTOMOBIL_CENA = "cena";
    public static final String DB_AUTOMOBIL_DATUM_VYROBY = "datum_vyroby";
    public static final String DB_AUTOMOBIL_NAJETO = "najeto";
    public static final String DB_AUTOMOBIL_ID_MODELU = "id_modelu";
    
    public static final String DB_BANKA_ID = "id";
    public static final String DB_BANKA_NAZEV_BANKY = "nazev_banky";
    
    public static final String DB_DOPLNEK_ID = "id";
    public static final String DB_DOPLNEK_CENA = "cena";
    public static final String DB_DOPLNEK_POPIS_DOPLNKU = "popis_doplnku";
    
    public static final String DB_DOP_VYBER_ID = "id";
    public static final String DB_DOP_VYBER_ID_DOPLNKU = "id_doplnku";
    public static final String DB_DOP_VYBER_ID_ZAKAZNIKA = "id_zakaznika";
    public static final String DB_DOP_VYBER_ID_PRODANEHO_AUTA = "id_prodaneho_auta";
    
    public static final String DB_FINANCOVANI_ID = "id";
    public static final String DB_FINANCOVANI_AKTUALNE_ZAPLACENO = "aktualne_zaplaceno";
    public static final String DB_FINANCOVANI_DATUM_SPLATNOSTI = "datum_splatnosti";
    public static final String DB_FINANCOVANI_POC_FINANCOVANI = "poc_financovani";
    public static final String DB_FINANCOVANI_ID_PRODANEHO_AUTOMOBILU = "id_prodaneho_automobilu";
    public static final String DB_FINANCOVANI_ID_STAV_FINANCOVANI = "stav_financovani";
    public static final String DB_FINANCOVANI_ID_ZAKAZNIKA = "id_zakaznika";
    
    public static final String DB_KATEGORIE_ID = "id";
    public static final String DB_KATEGORIE_TYP_KAROSERIE = "typ_karoserie";
    
    public static final String DB_MODEL_ID = "id";
    public static final String DB_MODEL_NAZEV_MODELU = "nazev_modelu";
    public static final String DB_MODEL_ID_KATEGORIE = "id_kategorie";
    public static final String DB_MODEL_ID_VYROBCE = "id_vyrobce";
    
    public static final String DB_OBJEDNAVKA_ID = "id";
    public static final String DB_OBJEDNAVKA_DATUM = "datum";
    public static final String DB_OBJEDNAVKA_DODAT_INFORMACE = "dodat_informace";
    public static final String DB_OBJEDNAVKA_ID_AUTOMOBILU = "id_autmobilu";
    public static final String DB_OBJEDNAVKA_ID_ZAKAZNIK = "id_zakaznik";
    public static final String DB_OBJEDNAVKA_ID_FINANCOVANI = "id_financovani";
    public static final String DB_OBJEDNAVKA_ID_SELLER = "id_seller";
    public static final String DB_OBJEDNAVKA_ID_STAVU_OBJEDNAVKY = "id_stavu_objednavky";
    
    public static final String DB_POISTENI_ID = "id";
    public static final String DB_POISTENI_KON_DATUM = "kon_datum";
    public static final String DB_POISTENI_MESICNI_PLATBA_VELIKOST = "mesicni_platba_velikost";
    public static final String DB_POISTENI_POC_DATUM = "poc_datum";
    public static final String DB_POISTENI_ID_POISTOVNY = "id_poistovny";
    public static final String DB_POISTENI_ID_PRODANEHO_AUTA = "id_prodaneho_auta";
    
    public static final String DB_POISTOVNA_ID = "id";
    public static final String DB_POISTOVNA_NAZEV_POISTOVNY = "nazev_poistovny";
    
    public static final String DB_PRODANE_AUTO_ID = "id";
    public static final String DB_PRODANE_AUTO_DATUM_PRODEJE = "datum_prodeje";
    public static final String DB_PRODANE_AUTO_DOHODNUTA_CENA = "dohodnuta_cena";
    public static final String DB_PRODANE_AUTO_MESICNI_PLATBA_DATUM = "mesicni_platba_datum";
    public static final String DB_PRODANE_AUTO_MESICNI_PLATBA_VELIKOST = "mesicni_platba_velikost";
    public static final String DB_PRODANE_AUTO_ID_AUTOMOBILU = "id_automobilu";
    public static final String DB_PRODANE_AUTO_ID_ZAKAZNIKA = "id_zakaznika";
    
    public static final String DB_PUJCKA_ID = "id";
    public static final String DB_PUJCKA_KON_DATUM = "kon_datum";
    public static final String DB_PUJCKA_MESICNI_SPLATKA = "mesicni_splatka";
    public static final String DB_PUJCKA_POC_DATUM = "poc_datum";
    public static final String DB_PUJCKA_ID_BANKY = "id_banky";
    public static final String DB_PUJCKA_ID_PRODANE_AUTO = "id_prodane_auto";
    
    public static final String DB_ROLE_ID = "id";
    public static final String DB_ROLE_DESCRIPTION = "description";
    public static final String DB_ROLE_NAME = "name";
    
    public static final String DB_STAV_FINANCOVANI_ID = "id";
    public static final String DB_STAV_FINANCOVANI_DESCRIPTION = "description";
    public static final String DB_STAV_FINANCOVANI_NAZEV_STAVU = "nazev_stavu";
    
    public static final String DB_STAV_OBJEDNAVKY_ID = "id";
    public static final String DB_STAV_OBJEDNAVKY_DESCRIPTION = "description";
    public static final String DB_STAV_OBJEDNAVKY_NAZEV_STAVU = "nazev_stavu";
    
    public static final String DB_VYROBCE_ID = "id";
    public static final String DB_VYROBCE_NAZEV_VYROBCE = "nazev_vyrobce";
    
    public static final String DB_ZAKAZNIK_ID = "id";
    public static final String DB_ZAKAZNIK_EMAIL = "email";
    public static final String DB_ZAKAZNIK_MENO = "meno";
    public static final String DB_ZAKAZNIK_MOBIL = "mobil";
    public static final String DB_ZAKAZNIK_HESLO = "password";
    public static final String DB_ZAKAZNIK_POZNAMKA = "poznamka";
    public static final String DB_ZAKAZNIK_PRIMENI = "primeni";
    public static final String DB_ZAKAZNIK_ID_ROLE = "role";
    
    public static final String DB_ZAKLADNI_VYBAVA_ID = "id";
    public static final String DB_ZAKLADNI_VYBAVA_ID_AUTOMOBILU = "id_automobilu";
    public static final String DB_ZAKLADNI_VYBAVA_ID_DOPLNKU = "id_doplnku";

    // other constants
    public static final long USER_ROLE_INVITOR = 1;
    public static final long USER_ROLE_CUSTOMER = 2;
    public static final long USER_ROLE_SELLER = 3;
    
    public static final long STAV_OBJEDNAVKY_KE_SCHVALENI = 1;
    public static final long STAV_OBJEDNAVKY_SCHVALENO = 2;
    public static final long STAV_OBJEDNAVKY_VYRIZENO = 3;
    public static final long STAV_OBJEDNAVKY_ZAMITNUTA = 4;
    
    public static final long STAV_FINANCOVANI_HOTOVOST = 1;
    public static final long STAV_FINANCOVANI_PUJCKA = 2;
    
    public static final int POJISTOVNA_ALIANZ = 1;
    public static final int POJISTOVNA_UNIQUA = 2;
    public static final int POJISTOVNA_CESKA_POJISTOVNA = 3;
    public static final int POJISTOVNA_GENERALI = 4;
    public static final int POJISTOVNA_KOOPERATIVA = 5;
    
    public static final int BANKA_KOMERCNI_BANKA = 1;
    public static final int BANKA_CSOB = 2;
    public static final int BANKA_POSTOVNI_SPORITELNA = 3;
    public static final int BANKA_UNICREDIT_BANK = 4;
    public static final int BANKA_CESKA_SPORITELNA = 5;
    public static final int BANKA_VOLKSBANK = 6;
    public static final int BANKA_GE_MONEY = 7;
    public static final int BANKA_MBANK = 8;
    public static final int BANKA_ZUNO = 9;
    
}
